# -*- coding:utf-8 -*-
import MySQLdb
import sqlite3

bdd=MySQLdb.connect('192.168.1.50','user','aeobib', 'mysql')
cur=bdd.cursor()
bddlite=sqlite3.connect("base_bibliothèque")
curbbdlite=bddlite.cursor()
cur.execute("SELECT * FROM bib")
for l in cur:
    print(l)
    print(l[1])
    curbbdlite.execute("INSERT INTO bib(ref,nom_livre, nom_auteur,nom_empr,nom_resa) VALUES(?,?,?,?,?)",l)
 
